This zip file contains the Consumption Data required for various QTCs.

Each Excel file has a number of work sheets, including Instructions and Pre-requisites. 

For any QTC requiring meter reads which does not have a Consumption Data excel file, the values described in the QTF Default Configuration Data should be used.

*** Version 3.0 06/10/2025 ***
QT-171 Consumption Data.xlsx - correction to LSPVDj formulae resulting in changes to v in Step 20 and Step40-50 tabs
QT-242 Consumption Data.xlsx - correction to LSPVDj formulae resulting in changes to v in Step 20 and Step40-50 tabs
QT-272 Consumption Data.xlsx - correction to LSPVDj formulae resulting in changes to v in Step 20 and Step40-50 tabs
LoadShape.xlsx - additional sheets for S_PFAEW 22, S_PFAEW 23, S_PFAIW 22 and S_PFAIW 23

*** Version 2.0 12/09/2025 ***
Various changes required since as a result of the configuration changes made to the QTF on 09/09/2025 - amending the Onboarding QTC offset from -5 days to +1 day (defect #55781)
QT-029 Consumption Data.xlsx - number of days of consumption in IF/PUB-021 amended
QT-030 Consumption Data.xlsx - number of days of consumption in IF/PUB-021 amended
QT-031 Consumption Data.xlsx - correction to pre-requisites
QT-047 Consumption Data.xlsx - number of days of consumption in IF/PUB-021 amended
QT-049 Consumption Data.xlsx - correction to pre-requisites
QT-070 Consumption Data.xlsx - correction to pre-requisites
QT-071 Consumption Data.xlsx - number of days of consumption in IF/PUB-021 amended
QT-078 Consumption Data.xlsx - number of days of consumption in IF/PUB-021 amended
QT-079 Consumption Data.xlsx - number of days of consumption in IF/PUB-021 amended
QT-080 Consumption Data.xlsx - correction to pre-requisites
QT-168 Consumption Data.xlsx - number of days of consumption in IF/PUB-021 amended
QT-169 Consumption Data.xlsx - number of days of consumption in IF/PUB-021 amended
QT-170 Consumption Data.xlsx - number of days of consumption in IF/PUB-021 amended
QT-171 Consumption Data.xlsx - correction to pre-requisites
QT-174 Consumption Data.xlsx - correction to pre-requisites
QT-177 Consumption Data.xlsx - correction to pre-requisites
QT-242 Consumption Data.xlsx - correction to pre-requisites
QT-259 Consumption Data.xlsx - correction to pre-requisites
QT-272 Consumption Data.xlsx - correction to pre-requisites
QT-275 Consumption Data.xlsx - correction to pre-requisites
QT-276 Consumption Data.xlsx - correction to pre-requisites
QT-277 Consumption Data.xlsx - correction to pre-requisites
QT-278 Consumption Data.xlsx - correction to pre-requisites

*** Version 1.0 05/08/2025 ***
LoadShape.xlsx
QT-029 Consumption Data.xlsx
QT-030 Consumption Data.xlsx
QT-031 Consumption Data.xlsx
QT-047 Consumption Data.xlsx
QT-049 Consumption Data.xlsx
QT-070 Consumption Data.xlsx
QT-071 Consumption Data.xlsx
QT-075 Consumption Data.xlsx
QT-076 Consumption Data.xlsx
QT-078 Consumption Data.xlsx
QT-079 Consumption Data.xlsx
QT-080 Consumption Data.xlsx
QT-168 Consumption Data.xlsx
QT-169 Consumption Data.xlsx
QT-170 Consumption Data.xlsx
QT-171 Consumption Data.xlsx
QT-174 Consumption Data.xlsx
QT-177 Consumption Data.xlsx
QT-242 Consumption Data.xlsx
QT-259 Consumption Data.xlsx
QT-272 Consumption Data.xlsx
QT-275 Consumption Data.xlsx
QT-276 Consumption Data.xlsx
QT-277 Consumption Data.xlsx
QT-278 Consumption Data.xlsx